import pandas as pd
import pymyasql

Host = '127.0.0.1'
User = 'root'
Password = ''
dbname='ShenzhenRealestate'

db = MySQLdb.connect(host=Host,port=3306,user=User,passwd=Password,db=dbname)
data = pd.read_sql('select * from House',db)
print (data)